package com.cn.mapper.dao.db5.PartsManagement;

import com.cn.bean.vo.PartsManagement.BusinessProjectTypeMapping;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface BusinessProjectTypeMappingDao {
    List<BusinessProjectTypeMapping> selectBusinessProjectTypeMapping(@Param("page") int page, @Param("limit") int limit, @Param("name") String name);

    int addBusinessProjectTypeMapping(@Param("ID") int ID, @Param("businessTypeID") int businessTypeID, @Param("itemType") int itemType, @Param("businessProjectID") int businessProjectID, @Param("description") String description, int status);

    int deleteBusinessProjectTypeMapping(@Param("ID") int ID);
    int upDateBusinessProjectTypeMapping(@Param("ID")int ID,@Param("businessTypeID")int businessTypeID,@Param("status")int status,@Param("itemType")int itemType,@Param("businessProjectID")int businessProjectID,@Param("description")String description);
    List<BusinessProjectTypeMapping> selectAll();

    List<BusinessProjectTypeMapping> selectBusinessProjectId(@Param("businessTypeID")int businessTypeID);
    //根据业务类型:查询业务项目与业务类型对照表
     Integer selectCountBusinessProjectTypeMapping(@Param("businessTypeID")int businessTypeID);
     //根据业务类型，查询设备结构主表
     Integer selectCountEquipmentStructureMain(@Param("businessTypeID")int businessTypeID);
 }
